SELECT 
    c8, 
    AVG(SUM(c1)) OVER(PARTITION BY c8 ORDER BY c1 RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) 
FROM "t_alltype.parquet" 
GROUP BY c1,c8
